Tabela LPersonICD

Definicja tabeli LPersonICD

Name

LPersonICD

Code

LPersonICD

Comment

Informacje o diagnozach zgonu oraz chorób przewleklych


Lista kolumn tabeli LPersonICD

Name

Code

LPersonICDID

LPersonICDID

ICDID

ICDID

PersonID

PersonID

DiagnosisKindID

DiagnosisKindID

Comments

Comments

Active

Active


Kolumna LPersonICDID tabeli LPersonICD

Definicja kolumny LPersonICDID tabeli LPersonICD

Name

LPersonICDID

Code

LPersonICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ICDID tabeli LPersonICD

Definicja kolumny ICDID tabeli LPersonICD

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli LPersonICD

Definicja kolumny PersonID tabeli LPersonICD

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna DiagnosisKindID tabeli LPersonICD

Definicja kolumny DiagnosisKindID tabeli LPersonICD

Name

DiagnosisKindID

Code

DiagnosisKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Comments tabeli LPersonICD

Definicja kolumny Comments tabeli LPersonICD

Name

Comments

Code

Comments

Data Type

VARCHAR2(512)

Mandatory

No

Comment

Komentarz do diagnozy


Kolumna Active tabeli LPersonICD

Definicja kolumny Active tabeli LPersonICD

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Lista kluczy tabeli LPersonICD

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPersonICD

Definicja klucza Identifier_1 tabeli LPersonICD

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment